CREATE TABLE [dbo].[FS_Confer]
(
[fdConID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdConID] DEFAULT (''),
[fdConBarCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdConBarCode] DEFAULT (''),
[fdConSelf] [bit] NOT NULL CONSTRAINT [DF_FS_Confer_fdConSelf] DEFAULT ((1)),
[fdConColl] [bit] NOT NULL CONSTRAINT [DF_FS_Confer_fdConColl] DEFAULT ((0)),
[fdConAdmin] [bit] NOT NULL CONSTRAINT [DF_FS_Confer_fdConAdmin] DEFAULT ((0)),
[fdConBreak] [bit] NOT NULL CONSTRAINT [DF_FS_Confer_fdConBreak] DEFAULT ((0)),
[fdStuNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuLong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuSpec] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuYearOut] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuIDCard] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuPoli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuHomeAdd] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuHealth] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuCensAdd] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStuTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitContractor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdUnitContractor] DEFAULT (''),
[fdUnitTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitAdd] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitPost] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUnitInfoNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdArchName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdArchName] DEFAULT (''),
[fdArchPost] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdArchAdd] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdUpDepart] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdUpDepart] DEFAULT (''),
[fdUnitPlace1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdUnitPlace1] DEFAULT (''),
[fdUnitPlace2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdUnitPlace2] DEFAULT (''),
[fdUnitPlace3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdUnitPlace3] DEFAULT (''),
[fdCont1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont1] DEFAULT (''),
[fdCont2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont2] DEFAULT (''),
[fdCont3] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont3] DEFAULT (''),
[fdCont4] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont4] DEFAULT (''),
[fdCont5] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont5] DEFAULT (''),
[fdCont6] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont6] DEFAULT (''),
[fdCont7] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont7] DEFAULT (''),
[fdCont8] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdCont8] DEFAULT (''),
[fdCreateAt] [datetime] NOT NULL CONSTRAINT [DF_FS_Confer_fdCreateAt] DEFAULT (getdate()),
[fdSendBy] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__FS_Confer__fdSen__0A096455] DEFAULT (''),
[fdSendAgain] [bit] NOT NULL CONSTRAINT [DF__FS_Confer__fdSen__0AFD888E] DEFAULT ((0)),
[fdSendAt] [datetime] NULL CONSTRAINT [DF__FS_Confer__fdSen__0BF1ACC7] DEFAULT (''),
[Note] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__FS_Confer__Note__0CE5D100] DEFAULT (''),
[SELFTIME] [datetime] NULL,
[COLLTIME] [datetime] NULL,
[ADMINTIME] [datetime] NULL,
[fdPage_Style] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdPage_Style] DEFAULT ('2007'),
[fdStuFmyTel] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_FS_Confer_fdStuFmyTel] DEFAULT (''),
[fdIsSettle] [bit] NOT NULL CONSTRAINT [DF_FS_Confer_fdIsSettle] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Confer] ADD CONSTRAINT [PK_FS_Confer] PRIMARY KEY CLUSTERED  ([fdStuNo]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'''''', 'SCHEMA', N'dbo', 'TABLE', N'FS_Confer', 'COLUMN', N'fdUnitPlace1'
GO
EXEC sp_addextendedproperty N'MS_Description', N'用人单位上级主管部门', 'SCHEMA', N'dbo', 'TABLE', N'FS_Confer', 'COLUMN', N'fdUpDepart'
GO
